﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace HeathCareSystem
{
    public class DanhSachYeuCauDAO
    {
        DataProvider dt = new DataProvider();

        public bool ThemDanhSachYeuCau(DanhSachYeuCauDTO dsycDTO)
        {
            string strSQL = string.Format("INSERT INTO DanhSachYeuCau (STT, MaXetNghiem) VALUES ('{0}', {1})", dsycDTO.STT, dsycDTO.MaXetNghiem);
            return dt.ExecuteNonQuery(strSQL);
        }

        public bool XoaToanBoDanhSach()
        {
            string strSQL = string.Format("DELETE DanhSachYeuCau");
            return dt.ExecuteNonQuery(strSQL);
        }
    }
}